TimeGroup

Entity Definition

Logical Name : TimeGroup
Physical Name : CO_GP_TM

A named set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TimeGroupID (PK) A unique identifier for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. ID_GP_TM Identity integer
Description The human readable description for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. DE_GP_TM DescriptionShort varchar(255)

Relationships

Parent Entity Verb Phrase Child Entity
TimeGroup is summarized to NozzleFuelingTransactionHistory
TimeGroup specifies timing of Z_CustomerMembershipProgramPointsEarnedRule
TimeGroup uses FuelItemPrice
TimeGroup delineates TillTenderLimitRuleAssignment
TimeGroup is part of WorkerAvailability
TimeGroup validates time for ZPromotionalOfferRewardDerivationRule
TimeGroup defines weekly schedule for Reward
TimeGroup defines ItemSalesProhibitionPeriodRule
TimeGroup includes TimeGroupTimePeriod

Logical Views containing TimeGroup

Logical View
Logical 01110 - Item Selling Rules - Restrictions View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02450 - Control Transaction - Drawer Limit
Logical 06100 - Calendar View
Logical 06500 - Time Groups View
Logical 11100 - Worker - Macro View
Logical 20000 - Forecourt Macro View
Logical 20020 - Forecourt Pricing View